Model Table PROJ FCST CONN CCO
This cube dimension represents connected change order information in Project
Budgeting and Forecasting based on the IFS Applications dimension DIM_PROJ_FCST_CONN_CCO.
All cubes that refers to this dimension will have the attributes and hierarchies
as described below.
Attributes
| Attribute |
Description (where applicable) |
| Change Order State | Change Order State |
| Connection Type | Connection Type |
| Forecast Connected Change Order | Key. Displayed as PROJECT_ID + ' - ' + cast(FORECAST_ID
as nvarchar) + ' - ' + CHANGE_OBJECT_ID + ' - ' + CHANGE_OBJECT_NAME |
| Forecast Connected Change Order Code | Change Object identity (CHANGE_OBJECT_ID) |
| Forecast Connected Change Order Name | Change Object name (CHANGE_OBJECT_NAME) |
| Forecast Id | Forecast identity |
| Project Id | Project identity |
| Sales Contract No | Sales Contract No |
| Sub Contract No | Sub Contract No |
Hierarchies
USED BY MODEL(S)
Data source Information
The data source for this object is defined using IFS Developer Tool. The data
source contains a number of transformations where the model reads data from the
last step, i.e. the Data source view name (DW Source View Name).
| Model Table |
DW Source view (SQL Server) |
BI Access View |
Referenced Information Source |
Recommended Access Type |
| PROJ FCST CONN CCO | DIM_PROJ_FCST_CONN_CCO_TM | DIM_PROJ_FCST_CONN_CCO_BI | DIM_PROJ_FCST_CONN_CCO | On Line |